STANDARDIZED WORK - Entering Policy Questions into Access Policy Question Database

Date/Version: 05/01/22 v.1

Process Owner: Policy Team

Review Cadence: Annually
Purpose - To outline the process of entering Policy Questions into the Policy Questions Database
Step (1,2,3..) Process Step (list of the critical process steps) Dialogue (clear and simple descriptions, appropriate level of detail for the task)
1.

Tracking Policy Questions (Personal Database)
  1. Open the personal Policy Questions Database in Access
  2. Select the Form view
  3. Enter into the Form:
  4. Office - the office where the requester is located
  5. Requester - the requester’s name
  6. Date Submitted - the date the question was submitted to the Policy Questions mailbox
  7. Category - the category(ies) the question pertains to (choose all that apply). If a question does not clearly fit into a specific category, choose “Other”.
  8. ATLAS # - the case number(s) in ATLAS (enter all that apply)
  9. Question - copy and paste the question (omit salutations)
  10. Requester’s Supervisor - the requester’s supervisor’s name (this may be left blank if unable to determine the supervisor)
  11. Assigned To - the name of the Policy Writer the question is assigned to
  12. Date Assigned - the date the question was assigned to the Policy Writer (may differ from the date submitted)
  13. Status - the status of the question (Assigned, Researching, Pending, Responded, Completed)
  14. Response - copy and paste the response provided (omit salutations)
  15. Date Responded - the date the response was provided to the requester
  16. Follow-Up Question - if the requester submits a follow-up question to the response, copy and paste the follow-up question (omit salutations)
  17. Follow-Up Response - copy and paste the response provided to the follow-up question
  18. Follow-Up Response - copy and paste the response provided to the follow-up question
  19. Comments - any relevant comments pertaining to the question
  20. Save the database.
2.

Transfer Questions from Personal Database to Team Database
  1. Select the Table view
  2. Choose the specific lines to be copied
  3. Hold ‘Shift’ and left click the first and last line to select the group of questions
  4. Right click in the highlighted group and select ‘Copy’
  5. Open the team Policy Questions Database in Access
  6. Select the Table view
  7. Scroll to the bottom of the Table
  8. Left click the bottom blank line on the asterisk ‘*’ at the far left of the Table
  9. Right click in the highlighted line and select ‘Paste’
  10. Answer ‘Yes’ to the question prompted
  11. Save the Database

DO NOT PRINT THIS PAGE FOR DISTRIBUTION

CHANGE LOG
Change Number Change Proposed Updated by?

Change Made?

Yes/No

 Reason Date Finalized
example Change font on all pages to pink Jane Doe No Pink not within approved standard font scheme 4/13/2018
1

 

 

 

 

 
2

 

 

 

 

 
3

 

 

 

 

 
4

 

 

 

 

 
5

 

 

 

 

 
6